create query for table t1 need to accept data only on working hours(MON-FRI and 9AM-6PM). create or replace trigger trg_time before insert or delete or update on t1 begin if to_char(sysdate,'DAY') in ('SATURDAY','SUNDAY') or to_char(sysdate,'HH24') not between '09' and '18' then raise_application_error(-20111,'Try in office working hours'); end if; end; /